package com.example.demo.mapper;

import com.example.demo.entity.Source;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface FlunkMapper {

    @Select("select stu_name,course_flunk from db.dashuju where course_flunk>0 order by course_flunk desc")
    List<Source> getDashujuFlunk();

    @Select("select stu_name,course_flunk from db.jisuanjiyingyong where course_flunk>0 order by course_flunk desc")
    List<Source> getJisuanjiyingyongFlunk();//计算机应用

    @Select("select stu_name,course_flunk from db.ruanjiangongcheng where course_flunk>0 order by course_flunk desc")
    List<Source> getRuanjiangongchengFlunk();//软件工程

    @Select("select stu_name,course_flunk from db.ruanjianjishu where course_flunk>0 order by course_flunk desc")
    List<Source> getRuanjianjishuFlunk();//软件技术

    @Select("select stu_name,course_flunk from db.wangluogongcheng where course_flunk>0 order by course_flunk desc")
    List<Source> getWangluogongchengFlunk();//网络工程

    @Select("select stu_name,course_flunk from db.wangluojishu where course_flunk>0 order by course_flunk desc")
    List<Source> getWangluojishuFlunk();//网络技术

    @Select("select stu_name,course_flunk from db.wulianwang where course_flunk>0 order by course_flunk desc")
    List<Source> getWulianwangFlunk();//物联网

    @Select("select stu_name,course_flunk from db.xinxiguanli where course_flunk>0 order by course_flunk desc")
    List<Source> getXinxiguanliFlunk();//信息管理
}
